package com.kedi.healthcenter.read.dao.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 
 *
 * @author: 	陈辽逊
 * @date: 		2019/7/13 12:32
 */
@Mapper
public interface OtherSourceMapper {
		
	/**
	 * 					获取肿瘤基因的信息所有数据
	 * @return			返回一个封装数据对象othersource
	 */
	@Select("SELECT o.other_source_id,o.title,"
			+ "CONVERT (content  USING utf8) AS content,"
			+ "o.url,o.phone "
			+ "FROM other_source  o WHERE o.status =1 ")
	List<Map<String, Object>> othersource();	
	/**
	 * 					预约表繁忙情况
	 * @return			返回一个封装数据对象othersource
	 */
	@Select("SELECT * FROM subscribe t WHERE t.status =1 ")
	List<Map<String, Object>> showSubscribe();

	/**
	* 方法实现说明 获取康复预约详情
	* @author      ytw
	*@param
	* @return
	* @exception
	* @date        2019/8/2 14:09
	*/
	@Select("select other_source_id,title,CONVERT (`content`  USING utf8) AS content,url,phone,status from other_source where source_class=3")
	List<Map<String, Object>> recoveryDetail();

	/**
	* 方法实现说明  免费体检
	* @author      ytw
	*@param
	* @return
	* @exception
	* @date        2019/8/2 15:20
	*/
	@Select("select other_source_id,title,CONVERT (`content`  USING utf8) AS content,url,phone,status from other_source where source_class=4")
	List<Map<String, Object>> freemedical();
}
